<?php

use Illuminate\Database\Migrations\Migration;

class CreateChitietcanbohuongdanTable extends Migration
{
    /**
    * Run the migrations.
    *
    * @return void
    */
    public function up()
    {
        Schema::create('chi_tiet_can_bo_huong_dan', function($table)
        {
            $table->engine='InnoDB';
            $table->increments('id')->unsigned();
            $table->integer('id_de_tai')->unsigned();
            $table->integer('id_can_bo')->unsigned();
            $table->integer('stt_vai_tro')->nullable()->default(null)->unsigned();
            $table->text('ghi_chu')->nullable()->default(null);
        });
    }

    /**
    * reverse the migrations.
    *
    * @return void
    */
    public function down()
    {
        Schema::drop('chi_tiet_can_bo_huong_dan');
    }
}